Prisma MCP Server

@Prisma

Visit Server

8 months ago

Manage Prisma Postgres databases with ease

Overview Tools Comments

Overview

What is Prisma MCP Server?

Prisma MCP Server is a service baked into the Prisma CLI (≥ v 6.6.0) that exposes the Model‑Context Protocol (MCP) for Prisma Postgres.

It enables large‑language‑model (LLM) agents—such as Claude Desktop, Cursor, Windsurf, or an OpenAI Agent—to provision databases, evolve schemas, and run queries with natural‑language instructions instead of raw SQL or REST calls.

How do I use it?

{
  "mcpServers": {
    "Prisma": {
      "command": "npx",
      "args": ["-y", "prisma", "mcp"]
    }
  }
}

Key features

Category	Highlights
Database provisioning	Create, list, and delete Prisma Postgres instances in any region.
Schema design & migrations	Brain‑storm a Prisma schema, generate migrations, and apply them—all via chat.
Query execution	Run ad‑hoc reads, writes, or multi‑statement transactions; results stream back as JSON.
Console automation	Log in, switch projects, or open Prisma Studio directly from chat.
AI‑tool integrations	One‑click setup for Cursor, Windsurf, Claude Desktop, Zed, and any OpenAI Agent.

Typical use cases

“Create a free Postgres instance in us‑east‑1 called my‑db.”
“Add a createdAt TIMESTAMP column to the User table and deploy the migration.”
“Give me an ER‑diagram‑style summary of the current schema.”
“Seed the Product table with 25 realistic test rows.”

Try in Playground

Server Config

{
  "mcpServers": {
    "Prisma": {
      "command": "npx",
      "args": [
        "-y",
        "prisma",
        "mcp"
      ]
    }
  }
}

Build with ShipAny.